comma problems in export to excel

Creating  a script to go though a module and output attribute base on filtering.  I have maybe ten different filter set ups and after each set up I output several attributes to  excel.   My last hurdle is cleaning up the excel  format.  My problem is that on many of the "Object Text" entries, it has multiple tabs and commas that are spreading this attribute across multiple cells.   Is there a way that I can out put this specific attribute that is not comma or tab delimitated and prints out the entire content into the next  cell?

 

Thank you

 


Reality - Sun Dec 18 16:45:12 EST 2016

Re: comma problems in export to excel
Mathias Mamsch - Mon Dec 19 07:40:32 EST 2016

We have several posts about csv export ... Here is one: 

https://www.ibm.com/developerworks/community/forums/html/topic?id=77777777-0000-0000-0000-000014627043&ps=25

You can try the "AddEscapedStringToBuffer" function to see if it resolves your problems. 

Regards, Mathias